<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Filtering data based on business attributes</title>
<link rel="stylesheet" href="RoboHTML_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='RoboHTML.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:square; }
img_whs2 { border:none; width:17px; height:17px; float:none; border-style:none; }
ol.whs3 { list-style:decimal; }
img_whs4 { border:none; width:17px; height:17px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nFiltering data based on business attributes");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Filtering data based on business attributes</h1>
<p>Using a view filter based on business attributes, you can view a subset 
 of report data that focuses on the business data you are interested in. 
 Narrowing the focus of a report to the business data that is of interest 
 of you enables another level of report analysis that can highlight business 
 trends and figures.</p>
<p>The steps below show you how to create a view filter with an attribute 
 qualification, as well as how to create the example scenario above. </p>
<h2>Prerequisites</h2>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>You need 
 the Web Use View Filter Editor privilege. This privilege is part of OLAP 
 Services.</p></li>
</ul>
<h2>
<a name=To_create_a_view_filter_with_an_attribute_qualification></a>To 
 create a view filter with an attribute qualification</h2>
<ol>
<li class=p-Steps><p class=Steps>Log into a project in MicroStrategy 
 Web. </p></li>
	
<li class=p-Steps><p class=Steps>Run the report in Grid View. </p></li>
	
<li class=p-Steps><p class=Steps>If the View Filter area is not displayed, 
 from the<span style="font-weight: bold;"><B> Tools</B></span> menu, select <span 
 style="font-weight: bold;"><B>View Filter</B></span>. </p></li>
	
<li class=p-Steps><p class=Steps>In the <span style="font-weight: bold;"><B>View 
 Filter</B></span> area, click <span style="font-weight: bold;"><B>Add Condition</B></span>. 
 </p></li>
	
<li class=p-Steps><p class=Steps>From &nbsp;the <span 
 style="font-weight: bold;"><B>Filter On </B></span>drop-down list, select an 
 attribute. </p></li>
	
<li class=p-Steps><p class=Steps>Choose <span style="font-weight: bold;"><B>Qualify</B></span> 
 to set a specific value-based condition, or choose <span style="font-weight: bold;"><B>Select</B></span> 
 to choose attribute elements from a list. </p></li>
	<ul type="square" class="whs1">
		
<li class=P-Steps-Bulleted-1><p class=Steps-Bulleted-1>If you choose 
 <span style="font-weight: bold;"><B>Qualify</B></span>, choose whether to filter 
 on the attribute's description (<span style="font-weight: bold;"><B>DESC</B></span>) 
 or <span style="font-weight: bold;"><B>ID</B></span> form. Then, select a comparison 
 operator such as Greater than. Enter a value in the field on the right 
 to finish defining the filter condition.</p></li>
		
<li class=P-Steps-Bulleted-2><p class=Steps-Bulleted-2>To compare 
 the attribute to another attribute, click the <span style="font-weight: bold;"><B>Attributes</B></span> 
 icon <img src="images/viewfilterattribute.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs2">. Then select another attribute to compare it to.</p></li>
		
<li class=P-Steps-Bulleted-2><p class=Steps-Bulleted-2>If you choose 
 <span style="font-weight: bold;"><B>Qualify</B></span> and are qualifying on 
 a date-related attribute, you can either type the day in or select it 
 from a calendar (if DHTML is enabled). Click the calendar icon next to 
 the date field, then click on a date to select it. </p></li>
		
<li class=P-Steps-Bulleted-1><p class=Steps-Bulleted-1>If you choose 
 <span style="font-weight: bold;"><B>Select</B></span>, choose <span style="font-weight: bold;"><B>In 
 List</B></span> or <span style="font-weight: bold;"><B>Not in List</B></span> to 
 include or exclude items that appear in the <span style="font-weight: bold;"><B>Selected</B></span> 
 list. Then choose elements from the <span style="font-weight: bold;"><B>Available 
 </B></span>list and add them to the <span style="font-weight: bold;"><B>Selected</B></span> 
 list.</p></li>
	</ul>
	<ol start="2" type="1" class="whs3">
		
<li class=P-Steps-Bulleted-2><p class=Steps-Bulleted-2>You can 
 use the Search for field to search for a particular attribute element. 
 See 
<a href="Search_syntax.htm">Using correct and efficient search syntax</a>. 
 </p></li>
	</ol>
	
<li class=p-Steps><p class=Steps>Click <span style="font-weight: bold;"><B>Apply</B></span> 
 icon <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs4"> to complete 
 the view filter qualification.</p></li>
	
<li class=p-Steps><p class=Steps>If the <span style="font-weight: bold;"><B>Auto-Apply 
 Changes</B></span> check box is cleared, click <span style="font-weight: bold;"><B>Apply</B></span> 
 to apply the view filter to the report. </p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
